GL Journal Lines SQL Query

select
jh.doc_sequence_value journal_entry_doc_number,
jl.je_line_num journal_entry_line_number,
cc.concatenated_segments gl_account_number,
jl.accounted_dr debit_amount,
jl.accounted_cr credit_amount,
jh.period_name period_name,
jh.default_effective_date effective_date,
jh.creation_date entry_date,
jh.created_by perparer_id,
jh.je_source je_source,
jh.description je_description

from
gl_je_headers jh,
gl_je_lines jl,
gl_code_combinations_kfv cc

where
jh.je_header_id=jl.je_header_id
and cc.code_combination_id=jl.code_combination_id
and jh.period_name='JAN-18'
and jh.status='P'